<%@ page import="java.sql.*,studentportal.*"%>
<html>
<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">
<p>&nbsp;
<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65"><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">&nbsp;<!--mstheme--></font></td>
  </tr>
</table>
<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="23%">
      <p align="center"><a href="Student_Persanal_InfoView.jsp">Personal Info</a></td>
    <td width="20%">
      <p align="center"><a href="Student_Certificates_InfoView.jsp">Certificates</a></td>
    <td width="20%">
      <p align="center"><a href="Student_Notification.jsp">Notifications</a></td>
    <td width="20%">
      <p align="center"><a href="Student_Security_InfoView.jsp">Security</a></td>
    <td width="20%">
      <a href="Home.html">Home</a></td>
  </tr>
</table>
<body>

<%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sid=(String)session.getAttribute("StudentId");
					System.out.println("STRING"+sid);
					String str="select * from student_master where student_id='"+sid+"'";
					ResultSet rs=st.executeQuery(str);
					rs.next();
					//Student stu=(Student)session.getAttribute("Student");
%>
<p align="center">&nbsp;</p>
<form method="POST" action="./StudentCertificates">
 
  <div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
      <tr>
        <td width="100%" colspan="2">
          <p align="center"><b>Student Certificates Information</b></td>
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="right">
        <p align="right">Student_No</td>
      <center>
      <td width="50%"><select size="1" name="sno">
	    <%
		 con=MySQLDriver.getConnection();
      	 st=con.createStatement();
		 rs=st.executeQuery("select student_id from student_master");
		 while(rs.next())
		 {
		 %>
			 <option><%=rs.getString(1)%></option>
			 <%}%>
	  </select></td>	
      </tr>
    </center>
    <tr>
      <td width="50%" valign="middle" align="right">
        <p align="right">TC</td>
      <center>
      <td width="50%"><input type="checkbox" name="TC" size="20" value="TC"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="right">CC</td>
        <td width="50%"><input type="checkbox" name="TC" size="20" value="CC"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="right">PC</td>
        <td width="50%"><input type="checkbox" name="TC" size="20" value="PC"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="right">marks Memos</td>
        <td width="50%"><input type="checkbox" name="TC" size="20" value="Morks Menos"></td>
      </tr>
      <tr>
        <td width="50%" valign="middle" align="right">Apply Date</td>
        <td width="50%"><input type="text" name="Adate" size="15"><font color="red"><b>YYYY-MM-DD</font></td>
      </tr>
	  <tr>
        <td width="100%" colspan="2" align="center">
			 <input type="submit" value="Apply" name="action">
          </td>
      </tr>	

      
    </table>
    </center>
  </div>
</form>
<p align="left">&nbsp;</p>


</body>

</html>
